home *** CD-ROM | disk | FTP | other *** search
/ Die Ultimative Software-P…i Collection 1996 & 1997 / Die Ultimative Software-Pakete CD-ROM fur Atari Collection 1996 & 1997.iso / d / dateiver / cia1_10 / spreadsh.eet / planung.cvs < prev    next >
Encoding:
Text File  |  1996-09-18  |  10.6 KB  |  61 lines
  1. 'Pos.','Aufwands/Ertrags-Art','1. Jahr','','2. Jahr','','3. Jahr','','Gesamt','','','','','','','','','','',''
  2. 'Nr.','','Betrag','%','Betrag','%','Betrag','%','Betrag','%','','','','','','','','','',''
  3. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  4. '1','Umsatzerlös','1600','100','2000','100','2400','100','[3,LINE()]+[5,LINE()]+[7,LINE()]','100','','','','','','','','','',''
  5. '2','Skontoertrag','0','[3,LINE()]/([3,4]*0.01)','0','[5,LINE()]/([5,4]*0.01)','0','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  6. '3','Bestandsveränderungen','0','[3,LINE()]/([3,4]*0.01)','0','[5,LINE()]/([5,4]*0.01)','0','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  7. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  8. '4','Gesamtleistung (1-3)','SUM([3,4]..[3,6])','[3,LINE()]/([3,4]*0.01)','SUM([5,4]..[5,6])','[5,LINE()]/([5,4]*0.01)','SUM([7,4]..[7,6])','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  9. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  10. '5','Wareneinsatz','[3,4]*0.24','[3,LINE()]/([3,4]*0.01)','[5,4]*0.24','[5,LINE()]/([5,4]*0.01)','[7,4]*0.24','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  11. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  12. '6','Brutto-/Rohertrag','[3,8]-[3,10]','[3,LINE()]/([3,4]*0.01)','[5,8]-[5,10]','[5,LINE()]/([5,4]*0.01)','[7,8]-[7,10]','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  13. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  14. '7','Skontoaufwand','[3,4]*0.01','[3,LINE()]/([3,4]*0.01)','[5,4]*0.01','[5,LINE()]/([5,4]*0.01)','[7,4]*0.01','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  15. '8','Vertreterprovisionen','[3,4]*0.227','[3,LINE()]/([3,4]*0.01)','[5,4]*0.227','[5,LINE()]/([5,4]*0.01)','[7,4]*0.227','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  16. '9','Verpackung u. Versand','[3,4]*0.02','[3,LINE()]/([3,4]*0.01)','[5,4]*0.02','[5,LINE()]/([5,4]*0.01)','[7,4]*0.02','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  17. '10','','0','[3,LINE()]/([3,4]*0.01)','0','[5,LINE()]/([5,4]*0.01)','0','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  18. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  19. '11','Summe Variabler Kosten','SUM([3,14]..[3,17])','[3,LINE()]/([3,4]*0.01)','SUM([5,14]..[5,17])','[5,LINE()]/([5,4]*0.01)','SUM([7,14]..[7,17])','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  20. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  21. '12','Deckungsbeitrag 1','[3,12]-[3,19]','[3,LINE()]/([3,4]*0.01)','[5,12]-[5,19]','[5,LINE()]/([5,4]*0.01)','[7,12]-[7,19]','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  22. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  23. '13','Finanzierungkosten','22.8','[3,LINE()]/([3,4]*0.01)','12','[5,LINE()]/([5,4]*0.01)','0','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  24. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  25. '14','Deckungsbeitrag 2','[3,21]-[3,23]','[3,LINE()]/([3,4]*0.01)','[5,21]-[5,23]','[5,LINE()]/([5,4]*0.01)','[7,21]-[7,23]','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  26. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  27. '15','Mieten','30','[3,LINE()]/([3,4]*0.01)','30','[5,LINE()]/([5,4]*0.01)','30','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  28. '16','Personalkosten','211.2','[3,LINE()]/([3,4]*0.01)','211.2','[5,LINE()]/([5,4]*0.01)','211.2','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  29. '17','Betriebssteuern','0','[3,LINE()]/([3,4]*0.01)','0','[5,LINE()]/([5,4]*0.01)','0','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  30. '18','Versicherungen','2.4','[3,LINE()]/([3,4]*0.01)','2.4','[5,LINE()]/([5,4]*0.01)','2.4','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  31. '19','Beiträge u. Gebühren','4.8','[3,LINE()]/([3,4]*0.01)','4.8','[5,LINE()]/([5,4]*0.01)','4.8','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  32. '20','KFZ-Aufwand','33.6','[3,LINE()]/([3,4]*0.01)','33.6','[5,LINE()]/([5,4]*0.01)','33.6','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  33. '21','Leasingaufwand','22.8','[3,LINE()]/([3,4]*0.01)','22.8','[5,LINE()]/([5,4]*0.01)','22.8','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  34. '22','Fahrt- u. Reiseaufwand','18','[3,LINE()]/([3,4]*0.01)','18','[5,LINE()]/([5,4]*0.01)','18','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  35. '23','Eingangsfrachten','0','[3,LINE()]/([3,4]*0.01)','0','[5,LINE()]/([5,4]*0.01)','0','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  36. '24','Reparaturen, Ersatzteile','0','[3,LINE()]/([3,4]*0.01)','0','[5,LINE()]/([5,4]*0.01)','0','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  37. '25','Bewirtung','3','[3,LINE()]/([3,4]*0.01)','3','[5,LINE()]/([5,4]*0.01)','3','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  38. '26','Energie (Gas,Strom,Wasser)','6','[3,LINE()]/([3,4]*0.01)','6','[5,LINE()]/([5,4]*0.01)','6','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  39. '27','Allg. Bürokosten (Porti,','','','','','','','','','','','','','','','','','',''
  40. '','Tel.,Tx.,Zeitschr. etc.)','32.4','[3,LINE()]/([3,4]*0.01)','32.4','[5,LINE()]/([5,4]*0.01)','32.4','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  41. '28','Rechts-u. Beratungsaufw.','9.6','[3,LINE()]/([3,4]*0.01)','9.6','[5,LINE()]/([5,4]*0.01)','9.6','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  42. '29','Rechnungswesen','12','[3,LINE()]/([3,4]*0.01)','12','[5,LINE()]/([5,4]*0.01)','12','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  43. '30','Geldverkehrsaufwand','12','[3,LINE()]/([3,4]*0.01)','12','[5,LINE()]/([5,4]*0.01)','12','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  44. '31','Schadensfälle (Kund.ford.)','9','[3,LINE()]/([3,4]*0.01)','9','[5,LINE()]/([5,4]*0.01)','9','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  45. '32','AfA','23.4','[3,LINE()]/([3,4]*0.01)','23.4','[5,LINE()]/([5,4]*0.01)','23.4','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  46. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  47. '33','Fixe Kosten Gesamt','SUM([3,27]..[3,45])','[3,LINE()]/([3,4]*0.01)','SUM([5,27]..[5,45])','[5,LINE()]/([5,4]*0.01)','SUM([7,27]..[7,45])','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  48. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  49. '34','A.O. Aufwand','205','[3,LINE()]/([3,4]*0.01)','200','[5,LINE()]/([5,4]*0.01)','200','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  50. '_____','_________________________','__________','__________','__________','__________','__________','__________','__________','__________','','','','','','','','','',''
  51. '35','Erfolg (Gewinn/Verlust)','','','','','','','','','','','','','','','','','',''
  52. '','vor Ertragssteuern','[3,25]-[3,47]-[3,49]','[3,LINE()]/([3,4]*0.01)','[5,25]-[5,47]-[5,49]','[5,LINE()]/([5,4]*0.01)','[7,25]-[7,47]-[7,49]','[7,LINE()]/([7,4]*0.01)','[3,LINE()]+[5,LINE()]+[7,LINE()]','[9,LINE()]/([9,4]*0.01)','','','','','','','','','',''
  53. '=====','=========================','==========','==========','==========','==========','==========','==========','==========','==========','','','','','','','','','',''
  54. '','','','','','','','','','','','','','','','','','','',''
  55. '','12.01.1989/CALC','','','','','','','','','','','','','','','','','',''
  56. '','Dr.L.Marte','','','','','','','','','','','','','','','','','',''
  57. '','','','','','','','','','','','','','','','','','','',''
  58. '','','','','','','','','','','','','','','','','','','',''
  59. '','','','','','','','','','','','','','','','','','','',''
  60. '','','','','','','','','','','','','','','','','','','',''
  61.